package com.yingsheng.bi.hks.repository.dao.service;

import com.yingsheng.bi.hks.basic.utils.Utils;
import com.yingsheng.bi.hks.dto.categories.CategoriesQryReq;
import com.yingsheng.bi.hks.repository.dao.mapper.CategoriesMapper;
import com.yingsheng.bi.hks.repository.dao.po.Categories;
import com.yingsheng.bi.hks.repository.dao.po.CategoriesExample;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;

import java.util.Date;
import java.util.List;

/**
 * stores表的数据库操作服务
 * 要求说明：
 * 1.一般情况下,要求参数不超过5个时方法入参逐个声明
 * 2.一般情况下,要求条件不超过3个时要在方法名上体现
 * 3.最好对方法入参做一定校验,尤其是对条件参数至少要做非空校验
 *
 * @author 83686
 */
@Repository
public class CategoriesDaoService implements DaoService {

    @Autowired
    private CategoriesMapper categoriesMapper;

    public boolean insert(Categories categories) {
        categories.setId(Utils.genUUid());
        int result = categoriesMapper.insert(categories);
        return result == 1;
    }

    public boolean updateById(Categories categories) {
        categories.setUpdateTime(new Date());
        int result = categoriesMapper.updateByPrimaryKey(categories);
        return result == 1;
    }

    public List<Categories> query(CategoriesQryReq req){
        CategoriesExample example = new CategoriesExample();
        example.createCriteria().andPidEqualTo(req.getPid());
        example.setOrderByClause("orders");
        return categoriesMapper.selectByExample(example);
    }

    public boolean del(String id){
        return categoriesMapper.deleteByPrimaryKey(id) == 1;
    }
}
